Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Fulltext Search
1) A MATCH expression for fulltext search can be used to order results
2) Alter table to add a fulltext index
3) Boolean Full-Text Searches
4) Boolean mode searches also allow you to exclude words
5) Boolean Search Expressions (IN BOOLEAN MODE)
6) Create a fulltext index on the combination of TITLE and SUMMARY
7) Creating a Full-Text Index
8) FULLTEXT search index
9) Full-Text Search syntax
10) FULLTEXT searching supports phrase searching in Boolean mode
11) Get the numbers and relevance values of the books in which distributed appears in the summary
12) Get the numbers and relevance values of the books in which the word introduction appears in the title
13) Get the numbers and titles of the books in which database appears in the title
14) Get the numbers and titles of the books in which the phrase design implementation appears
15) Get the numbers and titles of the books in which the word careers appears in the title andor the summary
16) Get the numbers and titles of the books in which the word database andor the word design appears
17) Get the numbers and titles of the books in which the word database appears
18) Get the numbers and titles of the books in which the word practical andor the word distributed appears in the
19) Get the numbers and titles of the books in which the word practical appears
20) Get the numbers and titles of the books in which the word to appears
21) Get the numbers and titles of the books in which the words database and design appear
22) Get the numbers and titles of the books in which words appear that begin with data
23) Give the numbers and titles of the books in which the word database appears, but not the word design
24) Give the numbers and titles of the books in which the word sql appears
25) In boolean mode
26) In Boolean search acts as a wildcard operator
27) In natural language mode
28) IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION
29) Match against a long sentence
30) Match two words in boolean mode
31) MATCH(TITLE) AGAINST (to)
32) Matches two columns
33) Matches two columns in boolean mode
34) Matches two words
35) Minus operator
36) Noise Words
37) Overview of Boolean Search Operators
38) Performing Phrase Searches with a FULLTEXT Index
39) Performs an OR search for any of the words
40) Precede each word in the search string with a + character and add IN BOOLEAN MODE after the string
41) Quotation in boolean mode
42) Requiring or Excluding FULLTEXT Search Words
43) Search a word in natural language mode
44) Search for a word
45) Use MATCH in where statement
46) Using fulltext index
47) Using match in select statement
48) Using match in where clause
49) Using plus operator in boolean mode
50) Using the same match against clause in select clause and where clause
51) You can include additional criteria to narrow the search further